<?php
	include $script['classConnexion'];
	$laBase = new clstBDD;
	$laBase->connecte($db ['dsn'],$db ['userid'],$db ['pass']);
	
	if ($laBase->getConnexion() != null) {
		//on interroge la base
		$sql='select PRA_NOM,PRA_NUM from praticien';
		$curseur = $laBase->requeteSelect($sql);
		$res=odbc_fetch_array($curseur);
		list($err, $donneesPraticiens) = obtenirDonnees($db ['dsn'],$db ['userid'],$db ['pass'], $sql);
		
		$sql2='select MED_NOMCOMMERCIAL,MED_DEPOTLEGAL from medicament';
		$curseur = $laBase->requeteSelect($sql2);
		$res = odbc_fetch_array($curseur);
		list($err, $donneesMedicaments) = obtenirDonnees($db ['dsn'],$db ['userid'],$db ['pass'], $sql2);
		
		$sql3='SELECT COUNT(*) AS NUM_RAP FROM RAPPORT_VISITE';
		$curseur2 = $laBase->requeteSelect($sql3);
		$res2=odbc_fetch_array($curseur2);
		$res2["NUM_RAP"] = $res2["NUM_RAP"] + 1;

	
	}
	
	$contenu = $page['FormRapportVisite'];
	$title = 'Form Rapport Visite';
?>